SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428999 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428999 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351624,1007060,275299,670441,305169,493274,526598,313581,109097,302635,263857,445930,700490,182054,569034,207998,1040090,500207,777759,355282,185712,656113,85097,306915,1022879,786486,963367,111135,739209,210396,802555,435052,492908,1034915,456989,238963,822879,1006159,1030878,400063,85315,203563,752791,771731,651099,425912,946115,334074,664486,1019790,438542,314187,389639,408351,548921,553990,1036501,553703,412456,994649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]