SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562988 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562988 [ RunTime:0.002287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618231,587430,303602,60910,1007753,582569,755609,822164,43960,184109,503209,925519,818282,909362,730038,915402,74639,118539,224650,447560,579880,258515,381052,37614,414448,480431,801921,70923,449009,892596,73753,23805,859469,735334,183705,990058,576750,906056,468364,935949,853629,499926,670627,62341,332427,414847,375110,190020,17228,165263,456020,533105,841027,980829,168006,354171,147155,551952,451639,988904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]