SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002616s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265457 LIMIT 1 [ RunTime:0.003434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265457 [ RunTime:0.001286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614556,1028242,624222,943238,452855,738108,878204,689940,404454,339658,460010,956865,902453,249892,787492,462421,200256,426343,1016902,215850,535024,198661,97687,390273,826312,289327,947893,112427,854099,21603,539628,682557,906392,17489,299516,1002282,241326,26293,417154,233766,261127,818922,869352,777721,363330,646716,618833,162285,13045,826573,597442,147523,421224,900423,131053,231038,470476,151216,15421,508879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]