SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543610 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543610 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (887204,46787,275170,907393,774901,13517,1043473,507396,218878,3160,583639,101234,893972,996254,28040,539016,995470,772549,969638,643363,658802,861629,1015736,35900,50256,789614,983819,869934,683389,396785,102911,509119,251463,776108,469960,611755,161563,176063,446165,769900,384302,27366,996152,852079,131833,250863,406510,704271,819798,1007080,623584,240362,751599,488481,426486,109725,610890,312269,321394,1034340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]