SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026117 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026117 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393600,190872,80261,458199,717386,485480,410048,593031,888335,158737,903334,441560,421021,282031,139534,373770,386389,709273,370423,1028106,181643,821316,553942,679068,546580,1022709,364639,235396,63919,583452,290728,1042407,433312,644352,623503,475999,1028294,239415,475996,793227,896652,512258,8722,454750,884416,671949,205967,704067,549026,155596,50276,251086,718565,761020,367572,517548,44832,843693,173902,656358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]