SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565693 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565693 [ RunTime:0.001409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78934,900340,108734,717753,410675,572003,746481,277147,946830,362812,532148,167890,598028,934599,512253,713105,210179,941205,819764,537716,935919,899174,250141,136921,778759,227998,321339,1008474,1024314,630272,146543,839857,348868,72304,377523,57627,1024009,646067,439347,546022,281387,970624,752588,736477,869716,667433,842299,218831,554010,125482,865986,723039,58666,2641,1030805,420111,42283,946452,343698,932256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]