SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503804 LIMIT 1 [ RunTime:0.000691s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503804 [ RunTime:0.001952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518289,45393,884033,260753,408719,111228,199934,852618,665408,514857,1026953,682568,574013,414437,324394,850064,250142,564103,1027051,994322,341292,103663,1019556,224561,642197,52009,257946,902750,566487,422041,753968,588144,17377,821025,20328,312172,138672,379784,130108,177213,1042117,956342,344903,848542,673449,229587,64808,449030,1017173,915755,378164,688261,168698,176477,608548,754041,263083,937208,129577,26022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000364s ]