SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026390 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026390 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835574,922838,194335,465849,30950,568734,231327,475907,231997,526456,870723,1032410,864257,673944,749938,819580,464312,782572,180204,590437,511963,1030506,961112,856401,615769,613048,496306,333592,406799,530504,862673,226634,382497,856623,843631,98818,927372,428787,367071,268000,792240,441217,899918,683320,184151,924668,782041,395092,150102,733488,115793,364619,481434,230231,468611,936277,847420,666695,548610,718018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]