SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005097 LIMIT 1 [ RunTime:0.001042s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005097 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858086,535157,259620,200124,795065,283094,573046,415643,862887,345115,45877,477729,753847,290673,334229,470108,773047,799815,898755,874810,170166,680448,201393,407717,744879,582581,434030,946062,733343,763597,452068,986338,203800,782684,212403,395418,1021757,69260,27210,52006,536725,806848,773019,535091,800799,565012,700816,236520,323789,122345,203771,812177,20035,75619,185296,441312,1030967,288697,156281,158626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]