SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474743 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474743 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112184,768837,397050,820283,194229,999463,713605,609399,453477,648049,100255,239022,187410,343296,738442,290802,425263,467730,342241,354968,779764,846560,520531,702766,540007,424813,23568,283656,217919,398823,588763,18646,260559,268177,1022931,541982,306999,800605,147610,146597,624583,937361,46418,1012004,520535,686971,929307,185377,221221,772811,651718,22269,325321,322562,275531,710021,532295,224791,216869,845851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]