SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507730 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507730 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832191,107128,1043298,449812,731642,250852,756527,423689,846066,161228,891635,33564,668542,38223,979523,380840,764240,540141,43480,175344,842032,824083,1045585,234672,592634,626448,255355,431183,599744,67564,952137,603268,111946,779047,976831,614534,82246,737928,861317,172694,198092,747840,494644,784608,553492,482479,154980,792044,211907,71790,583862,446466,1010953,256777,436489,806785,574603,456277,498206,878565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]