SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418247 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418247 [ RunTime:0.003662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183898,304175,984887,549493,230556,144950,37436,146648,169265,74868,31808,425239,1016162,963686,666047,696128,756378,395596,592701,904485,467104,465559,68091,1001870,26622,81236,393127,842028,874425,714314,235121,93804,561355,702919,179985,828618,3822,250791,977938,158881,907443,1006657,448548,273549,238077,387527,552292,894755,895684,824459,696740,583668,823074,783653,659484,890233,48088,701138,148681,636703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]