SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395409 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395409 [ RunTime:0.002673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477154,391287,425676,981508,80962,701113,345883,198745,486238,650516,801707,948580,408253,896157,428531,250462,136862,40714,481410,402425,532502,142366,861050,260113,648905,910817,611691,846305,501245,906483,1026294,1047381,246147,780108,963297,409853,66436,699414,955436,1009296,684859,839946,553463,809705,183750,317530,744739,627231,43516,331251,992800,583642,1034825,787032,661899,205516,924753,530664,979364,833027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]