SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020089 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020089 [ RunTime:0.003274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002036,596479,753178,678648,805868,882512,683633,931706,711082,687244,283581,858155,77318,22229,852981,337665,290407,1019649,328778,217625,908695,555628,545077,202903,892250,363278,870793,541855,419193,437445,443567,774509,973287,957337,297069,727544,710974,907182,22453,582133,379204,50879,559673,297563,460835,760449,95708,640765,238573,123794,738648,30305,74729,637082,650690,129236,738331,1036625,931078,860509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]