SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541191 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541191 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844541,453299,978598,448600,352197,475817,165593,22058,94463,918033,704036,855977,151401,818279,228542,904882,491376,925089,850135,292642,827257,496816,937274,747191,269020,415350,400330,324055,479534,194771,937996,1037543,910377,520259,606566,121307,287488,160381,833383,378068,915377,558515,841433,1006164,1017791,535488,76577,622248,444071,800755,358661,63540,714702,931196,834514,859726,133275,355394,326441,783512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]