SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 907063 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 907063 [ RunTime:0.002737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89805,539437,817750,1031291,112458,1035252,348793,319740,307223,757084,303501,1043683,255533,153178,199690,670247,1011174,258380,222868,93654,959907,925449,1020403,558195,959022,217223,83191,793528,357485,477454,381005,303291,975554,853474,316284,758598,506151,50471,715717,306308,1041513,211433,2875,680678,1034523,96542,536051,612206,179388,464014,768239,1007600,466495,820386,257835,776639,680483,573719,211606,54104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 907063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 907063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001774s ]