SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001999s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405451 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405451 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389322,165950,966852,144419,758067,725587,661627,954264,808276,512928,664012,368972,126183,842509,360623,975532,157529,678385,287115,405191,584335,871891,973269,287618,813799,961939,525767,1018239,612277,707401,786377,8572,959121,301847,118509,290148,268801,446049,647614,581833,88600,587588,968850,719218,452810,849003,97328,571142,141236,693115,698005,462770,730747,626607,1045909,412475,965393,2260,269524,957949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]