SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044299 LIMIT 1 [ RunTime:0.000589s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044299 [ RunTime:0.002268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236826,943022,1019955,436886,114496,285105,91811,567486,635053,508024,720243,773732,456692,272742,837592,263419,891876,675991,78445,900121,305600,38524,817257,752053,912591,720316,963229,145,1020158,385968,49516,829505,159654,789459,540263,929486,904675,207788,819342,935887,873518,785082,841013,867790,499213,547406,162684,802111,377894,1047568,788364,856496,753788,891878,907440,695282,849170,12967,601256,859067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]