SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501760 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501760 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972748,818520,240832,681244,280921,65507,452958,1037094,860816,210929,204091,280173,970822,657208,506190,391058,131801,925836,1048459,120126,861879,520576,915130,552666,547100,106203,393403,87822,393886,758167,384881,20896,27853,627942,165067,463166,28939,586225,894290,570156,572320,445680,706805,589135,505071,364839,724262,721552,576840,709796,808651,169186,808401,479737,332114,694258,633179,714713,1040610,1043598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004254s ]