SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023581 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023581 [ RunTime:0.001957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487683,900526,790609,669478,111436,897695,306461,610770,770835,313065,643798,160202,434022,169482,906415,919323,73032,818093,589535,869785,177261,201629,93009,182533,477446,943741,462230,787994,986357,485057,185372,427827,120378,698774,203755,89,383612,766225,9244,738015,164644,84049,416096,510472,923448,1003563,655464,705435,198178,60756,194611,500469,26910,719017,863392,715225,125276,491762,578184,964227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]