SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402661 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402661 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528594,385194,289026,696334,18538,294199,730571,300330,828586,161977,100486,575708,859213,400881,490000,232754,909193,287730,249079,208739,826499,893459,976320,13302,205143,116903,493453,314345,149641,709411,795759,733701,144970,243241,22310,389011,513042,624377,131170,470725,672528,949376,525952,150128,703220,704301,984459,869780,237277,361804,371737,332307,280332,734758,524491,661351,641607,313199,325711,859889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]