SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681814 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681814 [ RunTime:0.002608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143371,108835,886047,665243,981925,245921,428789,1029330,409605,478433,38196,156630,515852,241065,354967,887336,306787,247059,183571,1008395,717999,590625,379382,770962,412069,186051,962963,84323,547223,438658,956504,690519,252813,864380,1018340,959252,724259,354563,612621,670585,716795,507425,227212,190945,366767,580007,919849,879279,327820,646766,456966,716976,255513,12290,589660,180464,555266,891106,848219,168441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002482s ]