SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489097 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489097 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699249,495455,158472,1000210,961712,543139,274305,301042,711095,113778,908152,77964,609927,78725,939701,197000,942883,645615,1014611,203326,445242,65299,69432,798136,508831,47533,829527,969909,189814,387963,874489,480442,601422,893769,374910,695084,814052,423867,662195,363855,835490,21898,951917,214155,723997,671379,488943,846731,825777,671997,204877,1046643,784569,132400,223710,379910,97515,255104,694836,155356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]