SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68798 LIMIT 1 [ RunTime:0.000820s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68798 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485261,253386,179630,527347,195240,675135,605121,780643,511517,423801,544433,270068,373735,820257,566404,230663,865037,455421,156837,914051,468908,892425,112423,433318,240744,774734,567119,333704,803977,12037,386257,445535,919067,583455,1000415,171487,780079,818506,731502,605271,865514,409984,125355,783037,743889,899615,795293,491755,959755,468160,828361,133908,801058,1031618,594817,529408,961477,756869,48029,821539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]