SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567027 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567027 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136940,496466,143285,41965,304705,241309,830178,253164,134784,64852,521584,590476,5922,723933,288448,985974,397252,715286,353729,369122,12439,47605,156061,57125,471723,139080,186100,457528,772578,662608,59668,138805,217281,431063,831828,389426,33004,749432,580077,756793,730565,478206,872760,99285,214658,337508,51602,833594,450941,33684,125936,77610,909630,466906,123609,779613,511493,726278,645170,518011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002808s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001817s ]