SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310524 LIMIT 1 [ RunTime:0.000625s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310524 [ RunTime:0.002188s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (90413,321396,809577,481305,626346,950411,324008,673633,563869,763243,946287,659180,765359,801404,826591,265511,928,803524,481026,724282,396101,930069,565134,857103,815539,107292,149933,69828,643210,894825,760725,372961,653624,848471,310502,41198,983702,973781,163393,1009979,862416,1028836,351957,133468,256104,551898,662400,124211,735595,441036,649524,76850,527890,988004,106057,995497,349768,363463,882088,518842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]