SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317712 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317712 [ RunTime:0.002693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712734,974160,480960,112718,854928,256576,546240,125742,912579,322998,329178,970201,247795,962462,268297,310052,645424,648007,710526,85235,106031,60818,558044,24807,95970,665925,1000161,707239,923062,845622,57561,829645,121235,735273,484087,610378,22247,179316,3352,581194,763045,616603,173706,790515,946097,143613,392049,193104,664199,432902,901759,269880,238185,561879,279863,355765,378465,331517,1022844,704139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]