SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505076 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505076 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (966271,479804,533284,643395,831158,517896,467232,72524,316840,727253,97367,260809,695466,456119,214936,700226,1039599,112347,289633,342694,744439,572302,468158,699723,63662,946820,882753,800836,448899,180001,151266,651793,322848,840431,828966,685037,486875,520864,655964,308355,168232,234459,338462,841547,660956,399629,185367,576039,60994,507513,1035095,543720,815099,408369,633320,1039293,566798,477073,993455,716229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]