SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513236 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513236 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003244,281673,409061,401755,970900,236602,895216,371636,146931,726657,760286,124035,250343,265180,302907,322760,671084,161194,526680,626463,858137,1024494,224765,304540,286978,10634,581785,405294,881391,591186,571165,298220,146322,544715,532478,539252,266378,818113,579219,828580,559861,848448,765707,379620,989230,834022,68327,542182,34002,28260,1028782,509972,267607,937900,642540,886240,345149,392339,1041281,918889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]