SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594601 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594601 [ RunTime:0.001420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041485,727039,1018006,904352,640744,877780,416887,260815,710836,891835,663658,389646,955843,522758,294675,1023957,939685,669178,47560,1033196,453439,1005091,297304,1005218,959251,663587,859061,560662,580090,902538,761661,173615,465291,929687,436985,109183,690867,1046167,50214,368051,482762,193675,237166,432306,593657,635543,770222,31772,186067,817470,108739,133272,663572,928032,305927,983231,304579,526960,939562,86703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]