SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802904 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802904 [ RunTime:0.003457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714448,154668,976245,575417,371549,725710,6097,59601,329871,748666,795232,162230,849368,1012482,525841,926531,971378,106816,212424,1022054,982787,265311,370243,1016102,201702,968417,967599,427971,60103,933073,461723,410629,435477,361636,359096,797551,634135,235495,746164,579503,17890,758614,259480,228641,563496,1008398,790108,509823,818653,849624,413605,794328,807866,666931,211549,250807,924291,325840,781421,22556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]