SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004850s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531797 LIMIT 1 [ RunTime:0.001017s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531797 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1945,418334,636458,1031774,671098,646935,999765,282405,320261,520903,132430,873631,376250,233249,504712,635024,100834,91216,758957,385457,1028831,149032,283874,818448,962759,888309,955833,504729,689967,189266,10991,897699,512857,134328,381855,457004,712075,846033,497498,507277,705523,468565,802584,394945,1028744,74474,785893,607227,674015,810288,942893,904741,1039843,442859,113986,5946,513620,563113,547015,287353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001514s ]