SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491073 LIMIT 1 [ RunTime:0.004206s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491073 [ RunTime:0.007464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022881,341538,394142,294176,959696,721951,696109,1046486,750003,604089,770201,696308,942893,220800,681420,162862,1030791,421121,125924,395288,994088,518221,188675,740587,591615,357020,8508,579288,864033,717309,13312,645979,349903,193098,484848,82198,376425,129854,622964,321651,481222,804669,653975,97462,256059,673780,352915,317367,603107,555508,409846,77475,166918,815320,658026,819836,102189,558677,887706,30495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]