SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001931s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501871 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501871 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907040,860876,236045,58236,453052,1023453,985101,778140,752757,72134,256816,631441,446344,817962,454667,428356,239816,567664,705872,669042,198982,204057,132060,184490,1010449,737639,251160,809130,955729,284048,313886,511909,93406,779551,54132,119615,184948,664051,464791,833866,89639,599227,612050,297398,139701,836227,286417,604866,90889,363167,900456,714286,1028098,213583,438017,526013,933727,384566,680259,284602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]