SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012626 LIMIT 1 [ RunTime:0.000633s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012626 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664681,398502,822983,559300,592191,381570,470824,370445,368907,887612,540359,942846,427273,34286,146701,50862,271781,33720,1032986,904310,978351,444462,738451,322040,93626,226994,69656,1039618,616867,990784,851535,751434,837382,130048,471223,682891,637962,369647,833818,690155,98194,179615,95660,436007,963718,987928,705080,202497,382952,464112,1008059,911881,1024127,913458,955810,491196,461721,491640,115083,372524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]