SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315847 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315847 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872059,971210,1032386,33080,253570,1031283,135807,14283,578083,335846,668159,633886,266635,524811,708493,442407,355708,794108,879147,108887,1011707,511524,235792,299454,645455,798327,649282,432292,514211,391461,553838,646447,51052,679735,407931,615183,783112,579254,93124,754072,86901,778770,55315,115543,752759,1038766,61705,891575,58654,85131,922762,807881,228735,696912,168547,978398,42398,314367,839978,437281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]