SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387812 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387812 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326483,18415,131292,240432,547629,317666,223703,723033,82241,742761,884544,844739,806463,5909,73541,854223,140728,211864,1038227,546886,45437,363763,120443,880773,163253,219874,532673,75098,74551,551097,35926,1034360,937845,59848,7827,368140,446714,937261,192731,207927,165150,596499,832718,763521,359883,712117,144169,571227,815158,699342,648703,783565,215052,656174,163402,261477,208031,243045,966892,782587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000899s ]