SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105247 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105247 [ RunTime:0.003140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369968,1041246,507139,861306,773167,668841,534850,141939,447240,920791,954613,600836,560176,176424,892939,169087,1031050,576636,53838,641515,415058,931000,722307,378605,439353,221643,325230,552019,229582,45303,7218,992574,220247,581229,1006136,895375,560143,659047,540782,959903,884647,516588,699779,180339,242894,523299,237703,881464,963913,226417,1020494,470686,504084,459209,488090,369494,720395,377540,999490,828035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]