SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 321406 LIMIT 1 [ RunTime:0.004206s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 321406 [ RunTime:0.001170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724543,951029,853028,339831,98494,1039506,400790,945912,195620,368736,507415,198509,101435,615587,147903,358675,35852,668911,461179,761202,770809,564085,109906,1010527,955845,784465,884573,826130,378560,966845,408045,1040661,757704,559318,137305,67604,1011586,534606,207817,572091,971846,1033108,772690,167221,751649,796564,753052,55764,149919,1006022,658065,428946,629422,1026670,767393,291365,481715,248524,783537,473369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 321406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 321406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]