SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493370 LIMIT 1 [ RunTime:0.001800s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493370 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (966963,889761,908278,1015676,308908,545765,324850,447211,566088,466455,493920,601723,376594,742773,409179,812980,420913,485168,572570,1034864,744254,906015,296676,240953,234771,356502,387914,222523,694105,558105,434310,921453,394748,22333,823774,206108,294083,852595,1005078,613785,8758,75265,335659,591000,129836,71149,805147,827068,80279,470782,275356,760211,975429,735971,88217,586944,44744,540968,836106,717030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]