SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518081 LIMIT 1 [ RunTime:0.000760s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518081 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225786,465591,222278,322461,119848,344832,413504,296865,225198,178910,246840,274596,839797,421928,33005,486191,207381,905476,481276,294087,29294,407129,238326,199348,731986,970054,5237,539836,804803,792282,475003,204817,771942,536861,497920,269294,77849,46196,264073,155549,6438,816765,162764,973977,536795,622766,99792,758652,122712,774998,905986,548230,1014506,879998,394930,861565,667178,894240,849047,709747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001295s ]