SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281422 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281422 [ RunTime:0.004995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003560,189274,215134,110218,150406,933854,369873,24947,614771,361452,803489,556742,495763,958227,40990,105355,402576,1042907,369959,186216,1048861,1034972,201637,382369,575835,502289,530785,440006,364263,986489,373378,611034,840610,423180,646193,626635,315264,605295,119816,942415,1019536,28825,724810,781702,720112,1028042,139028,661930,258756,683180,685259,962406,380438,447248,715759,443358,43402,251625,145628,556559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]