SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438058 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438058 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681391,604685,217035,815749,103388,503331,309594,415448,862516,771159,981372,584632,243117,526163,61160,246275,993024,820390,246139,130515,867874,195341,911968,366796,357028,553638,18276,27702,290133,997089,638560,12880,738089,484224,234706,838734,956466,54287,753180,815367,621468,390296,686557,728548,1048798,683311,450070,404568,628022,998488,165024,229161,979327,227011,430436,923400,25895,475314,452087,617082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]