SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 172611 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 172611 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253014,498828,531508,678633,419200,424326,1013309,480127,267150,900791,311880,144584,118313,608583,161524,195364,620995,858017,962332,823903,877231,599053,201348,359759,914896,275376,1024534,167702,157123,181270,35701,793367,287286,441465,470260,477289,775792,803907,541928,560259,256254,453927,461788,122422,906017,1014995,612328,965986,670878,712343,350767,170513,576069,274933,925073,429624,466298,508219,861579,50830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 172611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 172611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]