SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413648 LIMIT 1 [ RunTime:0.001260s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413648 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845921,1023939,407313,471370,153842,135094,278572,185746,847461,910984,1031333,819239,186943,254745,117161,664824,723594,669583,880290,464594,963527,477335,33845,757176,976350,92481,498058,184622,299091,678361,619001,947025,86459,385622,890895,113614,94964,133239,959199,755587,504546,262566,581563,276081,54854,352242,580370,419041,21311,90630,353484,922396,114006,546239,338683,354416,914699,1005026,312247,573906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]