SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 17801 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 17801 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53241,36792,840683,1002233,146678,47741,533261,83670,994970,623964,612509,858860,737529,476688,27481,158966,705722,919471,20560,648553,185109,727578,1042448,849406,764435,136363,1001347,311208,959229,653794,1034747,894776,549160,22264,847902,308422,474310,3050,646634,94033,183464,192561,557907,60622,507062,404261,813004,696282,500519,977193,251282,964248,1035563,776093,98457,346859,641229,790949,59192,456774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 17801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 17801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]