SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488688 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488688 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420687,144877,620497,784379,252686,734645,770922,49037,342079,686735,378383,573841,830851,339859,931539,1008231,595191,970877,940387,93735,352966,121294,190619,277564,949801,624272,503494,750999,79855,538919,69441,715958,1031983,865264,969845,708930,3879,700716,889650,187299,205150,741210,425172,911310,440742,553509,892689,360296,1003303,77945,248313,380682,342164,648538,208841,134481,69028,425989,520230,876938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]