SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493846 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493846 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593438,901825,671310,124825,506864,981793,890990,950098,801395,511105,318735,522594,154467,85750,624399,616515,3326,380591,892838,480053,236011,697650,997719,109275,711331,278768,830714,1044305,778229,762063,182233,325689,980815,993084,827681,367352,43303,733618,652685,825245,456785,399839,148179,542191,319201,947492,485551,724916,871837,470385,429130,104524,704553,666241,1041736,500170,884851,311310,186501,129120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]