SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541057 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541057 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716728,163807,820560,735784,603279,948477,266013,702600,863531,453475,34716,322377,148127,391190,455590,863460,337730,131345,980735,399676,1010729,773928,1030917,774932,974247,72944,860134,24151,971149,976425,728319,291225,536881,240545,352627,58088,247048,632644,219805,460828,511660,292844,117776,13216,76997,569405,178530,873602,889094,574654,211205,358014,779699,462930,718919,139495,806827,1034487,107452,795059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]