SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001696s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 72140 LIMIT 1 [ RunTime:0.000708s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 72140 [ RunTime:0.002132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614566,861192,738938,464504,966385,873959,890622,1024884,798471,996636,684683,810199,295265,489167,117038,780669,16322,158919,914414,189403,962197,898381,20002,510773,677901,537455,800628,192025,291343,898230,610901,438833,652526,181896,560342,147701,907798,910881,69504,153221,238849,258841,367013,345450,646394,206158,802997,476164,685934,249009,661384,893549,81437,470649,298918,404386,961601,115909,931093,915727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 72140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 72140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]