SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019220 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019220 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142998,394026,198223,248682,68642,863038,958452,569585,114563,263117,450658,533247,982531,67309,117855,890396,189450,634555,875007,690349,605291,565833,39859,1007678,478815,484796,751175,350392,32482,568832,930503,793082,1010113,433417,797063,765688,240936,503541,902558,418656,44229,1033963,936207,535995,661811,505066,149704,63528,40422,922139,329685,476843,506246,803602,837900,60043,684366,17482,538941,703755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]