SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428094 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428094 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725703,60962,136614,604731,537143,704615,352298,914795,529584,661058,434157,623216,79372,388946,621740,418142,185265,939017,987369,1016301,886622,440701,734787,75027,860962,837216,576068,747730,1005046,596539,522217,310300,692369,128841,1040345,754124,772302,3836,467929,985288,574010,804474,744984,319899,397845,466009,240426,637925,536794,314345,499173,86528,131057,723402,474662,331813,291158,931832,31510,511795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]