SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001764s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114901 LIMIT 1 [ RunTime:0.000810s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114901 [ RunTime:0.002385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55811,115059,553090,169632,264961,538575,305394,809373,850580,1048052,506265,489095,981531,588549,259135,939531,827240,113922,457663,211021,1039842,596230,587038,984007,81507,179503,634602,605212,263380,930938,843073,1020061,513967,908391,723593,239262,637356,28884,378060,19126,203332,519210,995550,842066,342154,8081,956767,529546,388974,504364,493199,1030989,533171,302289,966116,458532,467369,335535,164419,420400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]