SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345222 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345222 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360902,351816,1016686,120812,534203,1017381,164031,161514,218672,547040,513151,218143,49414,642970,254537,639136,614706,966620,724035,794988,266522,194327,102676,540318,1010535,985140,648386,1005130,1021298,67398,123642,455945,201934,245562,535877,79965,659774,110037,16625,137862,931430,112232,1711,507296,461490,891879,663334,896041,509163,873796,600819,769654,375943,555816,518038,467844,36497,612402,959660,860561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]