SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470599 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470599 [ RunTime:0.002092s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299491,56083,1012197,719304,1020471,739158,680569,265302,36827,116380,5902,718983,302526,904804,39131,494140,81840,516846,367692,456588,88590,608474,608615,600861,925860,76996,506701,105521,419800,117242,888335,671411,1039443,85001,385416,497009,1032773,267387,34731,515861,307955,80746,141832,507350,361014,56047,451956,402999,413918,724782,306788,132388,644076,162387,492988,463284,412993,449321,475171,972060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000750s ]