SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 258980 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 258980 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482232,581512,962698,459363,788713,80577,612735,996855,852562,867040,101633,612252,467964,434326,401801,971018,312853,365958,895372,738403,673507,841169,963134,680917,128078,999565,910943,847521,379661,147015,886880,538562,1004499,394249,206067,22770,908776,788588,967374,651629,991074,943484,569779,64370,671084,153617,544984,290280,245643,549099,501114,379908,262906,266679,589326,981694,814963,301799,80409,142525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 258980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 258980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002671s ]