SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398679 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398679 [ RunTime:0.002342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318616,671666,552058,569914,679688,197538,662345,766113,131275,193099,687394,770940,375164,848297,845996,553185,1045435,208496,369095,658076,698551,292015,800790,85565,57115,183084,803037,960021,384853,339795,350719,251250,768282,209705,454808,5739,565517,759193,55624,701326,47390,765695,287970,884119,336791,497731,321220,683529,231852,242318,589898,796942,471662,632152,56475,554834,361359,719073,866975,90773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]