SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004645s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335653 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335653 [ RunTime:0.003056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410262,618046,276103,419164,325055,634182,823595,274334,595979,768322,689691,443084,690910,4501,965907,69581,180185,23436,730486,52012,932984,973741,365148,535567,697105,154506,227181,1623,496220,714249,843822,667153,826412,370844,36342,886776,19040,703027,344065,477199,956644,813609,881213,224595,1009663,573393,184896,710919,487690,345563,290101,237776,499457,1025856,633869,354159,771700,605590,879716,303115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001574s ]