SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465753 LIMIT 1 [ RunTime:0.004780s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465753 [ RunTime:0.004928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729075,248773,707341,232490,540834,562460,224452,1004550,713895,91297,888809,939228,1039894,560874,980903,512742,508315,257348,316116,103155,41496,207878,111750,422160,1015390,987537,485503,905624,570419,582101,531297,1018480,863413,65994,658903,653568,809454,421369,18119,14206,773504,894765,862270,230509,696039,635808,597590,713281,99162,504244,207799,200327,322756,433497,547972,143731,479755,669528,88965,92215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001081s ]