SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504091 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504091 [ RunTime:0.005235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831703,694099,380373,192222,473034,734494,450216,199868,335314,304599,621197,512937,663998,475768,630368,1013092,632289,787769,485197,255801,446611,796591,861997,62544,404886,977487,684871,333714,400469,76968,723838,326961,419277,246519,648555,664869,967541,237518,851783,788672,32879,158706,194186,651795,891351,910366,14364,284050,462423,168978,418246,705785,68852,227444,971209,580898,261677,427450,863461,937696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]