SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028534 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028534 [ RunTime:0.002074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633559,416627,965843,590436,488688,588427,493775,985462,337158,109701,1038097,864236,15772,444764,184518,204631,268943,430530,284105,862842,286931,765298,17267,106822,562112,184355,235707,297632,225355,598378,982545,488079,963649,586260,273564,95195,449451,758248,472484,96239,514453,446826,612217,588361,330274,425621,947881,695322,781755,330769,333792,209121,431965,117541,272250,1024424,401838,660686,1028639,567472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001288s ]