SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522580 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522580 [ RunTime:0.001388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803578,486624,543010,387965,161169,855953,930140,312416,945061,947037,277611,871598,482011,162059,366073,81592,279516,864180,855530,487227,721199,294039,253296,445938,1008212,984299,818540,857172,947240,262952,764333,385322,575566,238641,603503,488301,167472,153812,783167,703958,165080,551997,175359,135424,778906,238470,498765,718726,837271,942208,63422,1048610,1027904,459298,554449,691399,669489,977424,481558,554342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]