SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285429 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285429 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513073,113388,81248,886743,987212,91179,169287,570421,404859,120668,716996,31889,296076,1047958,69013,357242,576169,406317,51867,736885,877469,613959,73103,967823,761717,751662,638260,639753,151719,136606,124312,126669,993703,568388,66113,587539,914513,548670,311884,1048133,291529,600030,96361,219379,877669,14631,483120,89014,711940,955156,274650,454118,248144,827339,377494,928343,556811,1019665,529802,176211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001105s ]