SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534373 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534373 [ RunTime:0.005370s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319225,102445,1022412,1029308,14558,907889,693218,330134,1006026,479390,435310,363464,173145,956870,642479,12228,998774,15825,730216,22486,628569,205638,341158,1005754,668156,789113,601445,908822,539300,26692,530967,189317,1003695,908459,756806,89558,826839,821361,701548,956428,204388,952968,729629,281930,286453,929205,548299,488741,650061,66818,889406,674260,572841,856720,938317,215912,830849,26187,1036016,223590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534373 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534373 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]