SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492159 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492159 [ RunTime:0.006912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410650,501582,1001784,368538,782959,401234,161439,634976,428899,196982,57499,656009,30686,195229,351352,777970,451303,687021,275698,999471,124581,498456,535334,57230,527620,195664,145708,399593,359969,61136,219058,279661,861276,268043,660496,749090,786926,804413,741255,922102,247172,193981,485764,866594,333341,918545,219794,753853,39791,62910,589273,624166,680679,894184,687302,340496,1004246,208976,1019908,736625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]