SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015001 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015001 [ RunTime:0.003987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161718,90222,925139,130532,601744,75899,517015,1037219,5084,181391,897739,375581,840682,258406,821032,560974,331732,282160,131666,851914,836329,139897,390005,318692,314118,203381,151079,76301,368126,305185,857323,610758,786263,976258,887441,636883,890292,785216,224558,856167,584142,501731,353952,163149,819594,259626,150079,705388,90901,84668,299045,1026310,550469,905677,222790,879608,126008,521364,813128,634844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]