SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 67289 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 67289 [ RunTime:0.002531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41884,236892,436538,692228,517515,565116,453958,1024096,1026465,659159,944790,664038,891807,35877,609889,679003,539334,193801,385259,728601,324375,561353,631137,850438,494676,615271,447900,1022226,225599,275351,1038709,80507,1036714,178748,658143,877411,448620,939155,134028,314129,721780,471758,387625,406986,571367,583164,249776,970181,402049,942890,309138,40619,846940,992205,164110,621567,21602,305149,615090,502729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 67289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 67289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000967s ]