SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001632s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304419 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304419 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314620,264140,379147,498298,854760,66136,322771,366885,286545,570403,490134,921694,708323,728311,951694,345068,254804,910917,219250,820138,48374,103075,569465,951721,407064,566389,349386,857995,840370,792190,150394,234457,13085,527203,622501,87295,682300,438709,55488,185638,468873,862852,971350,900463,190024,967895,574464,155644,996275,417058,200085,160667,87282,896300,259300,801393,90024,517288,217963,735548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]