SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526678 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526678 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5774,580229,612409,1048769,26830,396355,401872,616672,938853,953679,303183,1047617,203082,293767,416796,160763,139199,324359,420952,22896,676918,443284,945045,280863,856181,683682,1007713,28543,117188,942340,467077,889813,671833,288231,439559,551808,1018534,904022,301746,814516,479254,671651,544451,813423,118106,633639,650693,181761,380219,824442,739314,97914,849838,203947,238513,171213,863913,517337,705140,612638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]