SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451583 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451583 [ RunTime:0.006194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620727,79495,298723,108450,485931,301556,314129,509733,962246,901286,98571,599192,523694,1005012,691308,626251,375806,36011,439419,746823,201898,690567,249443,203305,176205,58230,233473,99982,85725,727851,195285,495304,25691,540862,530333,1007643,272476,247526,308631,827357,641894,808472,524867,91369,397302,836777,710521,429594,107156,170477,503439,492476,979160,203134,891982,976545,662728,150281,216866,242194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002545s ]